package com.wlf.Entity;

import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.annotation.format.DateTimeFormat;
import com.alibaba.excel.annotation.format.NumberFormat;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;

import java.time.LocalDateTime;

@Data
@NoArgsConstructor
@AllArgsConstructor
public class SalesForecastTable {

    // 送货方式
    @ExcelProperty(value = "送货方式",index = 0)
    private String method;
    // 配送中心仓库编码
    @ExcelProperty(value = "配送中心仓库编码",index = 1)
    private String id;
    // 门店/仓编码
    @ExcelProperty(value = "门店/仓编码",index = 2)
    private String storesId;
    // 商品名称
    @ExcelProperty(value = "商品名称",index = 3)
    private String name;
    // 商品SKU
    @ExcelProperty(value = "商品SKU",index = 4)
    private String SKU;
    // 标签类型-标签值
    @ExcelProperty(value = "标签类型-标签值",index = 5)
    private String label;
    // 建议量(基础单位)
    @ExcelProperty(value = "建议量(基础单位)",index = 6)
    private String numberB;
    // 采购单价(基础单位)
    @ExcelProperty(value = "采购单价(基础单位)",index = 7)
    private String PPB;
    // 供应商编码
    @ExcelProperty(value = "供应商编码",index = 8)
    private String supplierId;
    // 建议量(采购单位)
    @ExcelProperty(value = "建议量(采购单位)",index = 9)
    private String numberP;
    //采购单位
    @ExcelProperty(value = "采购单位",index = 10)
    private String purchasingUnits;
    // 换算关系
    @ExcelProperty(value = "换算关系",index = 11)
    private String conversionRelationship;
    // 采购单价(采购单位)
    @ExcelProperty(value = "采购单价(采购单位)",index = 12)
    private String PPP;
    // 配送中心仓名称
    @ExcelProperty(value = "配送中心仓名称",index = 13)
    private String deliveryCenterWarehouseName;
    // 门店/仓名称
    @ExcelProperty(value = "门店/仓名称",index = 14)
    private String storesName;
    // 一级品类
    @ExcelProperty(value = "一级品类",index = 15)
    private String Level1Ctegory;
    // 二级品类
    @ExcelProperty(value = "二级品类",index = 16)
    private String Level2Ctegory;
    // 三级品类
    @ExcelProperty(value = "三级品类",index = 17)
    private String Level3Ctegory;
    // 商品SPU
    @ExcelProperty(value = "商品SPU",index = 18)
    private String SPU;
    // 商品UPC
    @ExcelProperty(value = "商品UPC",index = 19)
    private String UPC;
    // 规格
    @ExcelProperty(value = "规格",index = 20)
    private String specification;
    // 重量(g)
    @ExcelProperty(value = "重量(g)",index = 21)
    private String weight;
    // 基本单位
    @ExcelProperty(value = "基本单位",index = 22)
    private String baseUnits;
    // 上线状态
    @ExcelProperty(value = "上线状态",index = 23)
    private String status;
    // 零售价
    @ExcelProperty(value = "零售价",index = 24)
    private String retails;
    // 可售状态
    @ExcelProperty(value = "可售状态",index = 25)
    private String availableStatus;
    // 采购状态
    @ExcelProperty(value = "采购状态",index = 26)
    private String procurementStatus;
    // 采购属性
    @ExcelProperty(value = "采购属性",index = 27)
    private String procurementProp;
    // 可用库存(中心仓)
    @ExcelProperty(value = "可用库存(中心仓)",index = 28)
    private String availableInventoryC;
    // 在途库存(中心仓)
    @ExcelProperty(value = "在途库存(中心仓)",index = 29)
    private String transportingInventoryC;
    // 可用库存
    @ExcelProperty(value = "可用库存",index = 30)
    private String availableInventory;
    // 在途库存
    @ExcelProperty(value = "在途库存",index = 31)
    private String transportingInventory;
    // 计划调拨量
    @ExcelProperty(value = "计划调拨量",index = 32)
    private String plannedAllocations;
    // 采购待确认量
    @ExcelProperty(value = "采购待确认量",index = 33)
    private String confirmedProcurementNumber;
    // 在途创建时间
    @ExcelProperty(value = "在途创建时间",index = 34)
    private String createTime;
    // 要货量
    @ExcelProperty(value = "要货量",index = 35)
    private String askedNumber;
    // 库存可销天数
    @ExcelProperty(value = "库存可销天数",index = 36)
    private String sellableProcurementDays;
    // 补货策略
    @ExcelProperty(value = "补货策略",index = 37)
    private String replenishmentStrategies;
    // 补货周期
    @ExcelProperty(value = "补货周期",index = 38)
    private String replenishmentCycle;
    // 补货时间
    @ExcelProperty(value = "补货时间",index = 39)
    private String replenishmentTime;
    // 库存容量
    @ExcelProperty(value = "库存容量",index = 40)
    private String inventoryCapacity;
    // 安全库存
    @ExcelProperty(value = "安全库存",index = 41)
    private String safeInventory;
    // 库存容量天数
    @ExcelProperty(value = "库存容量天数",index = 42)
    private String inventoryCapacityDays;
    // 安全库存天数
    @ExcelProperty(value = "安全库存天数",index = 43)
    private String safeInventoryDays;
    // 起订量(基础单位)
    @ExcelProperty(value = "起订量(基础单位)",index = 44)
    private String moqB;
    // 预记采购总价
    @ExcelProperty(value = "预记采购总价",index = 45)
    private String estimatedTotalPurchasePrice;
    // 供应商
    @ExcelProperty(value = "供应商",index = 46)
    private String suppliers;
    // 到货天数
    @ExcelProperty(value = "到货天数",index = 47)
    private String arrivalDays;
    // 上次补货时间
    @ExcelProperty(value = "上次补货时间",index = 48)
    private String lastReplenishmentTime;
    // 上次补货数量(基础单位)
    @ExcelProperty(value = "上次补货数量(基础单位)",index = 49)
    private String lastReplenishmentNumberB;
    // 上次补货单价(基础单位)
    @ExcelProperty(value = "上次补货单价(基础单位)",index = 50)
    private String lastReplenishmentPriceB;
    // 30天总销量
    @ExcelProperty(value = "30天总销量",index = 51)
    private String totalSales30;
    // 14天总销量
    @ExcelProperty(value = "14天总销量",index = 52)
    private String totalSales14;
    // 7天总销量
    @ExcelProperty(value = "7天总销量",index = 53)
    private String totalSales7;
    // 综合日均销量
    @ExcelProperty(value = "综合日均销量",index = 54)
    private String DailySales;
    // 30天日均销量
    @ExcelProperty(value = "30天日均销量",index = 55)
    private String DailySales30;
    // 14天日均销量
    @ExcelProperty(value = "14天日均销量",index = 56)
    private String DailySales14;
    // 7天日均销量
    @ExcelProperty(value = "7天日均销量",index = 57)
    private String DailySales7;
    // 周三7月10日
    @ExcelProperty(value = "周三7月10日",index = 58)
    private String Wednesday710;
    // 周四7月11日
    @ExcelProperty(value = "周四7月11日",index = 59)
    private String Thursday711;
    // 周五7月12日
    @ExcelProperty(value = "周五7月12日",index = 60)
    private String Friday712;
    // 周六7月13日
    @ExcelProperty(value = "周六7月13日",index = 61)
    private String Saturday713;
    // 周日7月14日
    @ExcelProperty(value = "周日7月14日",index = 62)
    private String Sunday714;
    // 周一7月15日
    @ExcelProperty(value = "周一7月15日",index = 63)
    private String Monday715;
    // 周二7月16日
    @ExcelProperty(value = "周二7月16日",index = 64)
    private String Tuesday716;
    // 连续缺勤时常(小时)
    @ExcelProperty(value = "连续缺勤时常(小时)",index = 65)
    private String absencesTime;
    // 缺勤销售损失(元)
    @ExcelProperty(value = "缺勤销售损失(元)",index = 66)
    private String absencesLostSales;
    // 供应商商品编码
    @ExcelProperty(value = "供应商商品编码",index = 67)
    private String supplierCommodityId;
    // 供应商商品下单比例
    @ExcelProperty(value = "供应商商品下单比例",index = 68)
    private String supplierCommodityOrderRatio;
    // 供应商商品名称
    @ExcelProperty(value = "供应商商品名称",index = 69)
    private String supplierCommodityName;
    // 供应商商品规格
    @ExcelProperty(value = "供应商商品规格",index = 70)
    private String supplierCommoditySpecs;
    // 供应商商品备注
    @ExcelProperty(value = "供应商商品备注",index = 71)
    private String supplierCommodityNote;
    // 供应商商品链接
    @ExcelProperty(value = "供应商商品链接",index = 72)
    private String supplierCommodityLink;
    // 渠道名称
    @ExcelProperty(value = "渠道名称",index = 73)
    private String channelName;
    // 是否满足补货点
    @ExcelProperty(value = "是否满足补货点",index = 74)
    private String flag;
}
